﻿-- sql command for comments
SELECT *, UserProfile.UserId AS RegisteredUser FROM Comment LEFT JOIN UserProfile ON UserProfile.UserId = Comment.userId